﻿CREATE TABLE [dbo].[aspnet_Membership]
(
[ApplicationId] [uniqueidentifier] NOT NULL,
[UserId] [uniqueidentifier] NOT NULL,
[Password] [nvarchar] (128) COLLATE Cyrillic_General_BIN NOT NULL,
[PasswordFormat] [int] NOT NULL,
[PasswordSalt] [nvarchar] (128) COLLATE Cyrillic_General_BIN NOT NULL,
[MobilePIN] [nvarchar] (16) COLLATE Cyrillic_General_BIN NULL,
[Email] [nvarchar] (256) COLLATE Cyrillic_General_BIN NULL,
[LoweredEmail] [nvarchar] (256) COLLATE Cyrillic_General_BIN NULL,
[PasswordQuestion] [nvarchar] (256) COLLATE Cyrillic_General_BIN NULL,
[PasswordAnswer] [nvarchar] (128) COLLATE Cyrillic_General_BIN NULL,
[IsApproved] [bit] NOT NULL,
[IsLockedOut] [bit] NOT NULL,
[CreateDate] [datetime] NOT NULL,
[LastLoginDate] [datetime] NOT NULL,
[LastPasswordChangedDate] [datetime] NOT NULL,
[LastLockoutDate] [datetime] NOT NULL,
[FailedPasswordAttemptCount] [int] NOT NULL,
[FailedPasswordAttemptWindowStart] [datetime] NOT NULL,
[FailedPasswordAnswerAttemptCount] [int] NOT NULL,
[FailedPasswordAnswerAttemptWindowStart] [datetime] NOT NULL,
[Comment] [ntext] COLLATE Cyrillic_General_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]


GO
EXEC sp_tableoption '[dbo].[aspnet_Membership]', 'text in row', 3000

